{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["June13c"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"June13c","index":0,"n_rows":40,"n_cols":37,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,0,0,27],[6,28,7,28],[6,29,7,29]]}
["June 13 Calculator"]
[null,"q1","q2","q3","q4","q5","q6","q7","q8","q9","q10","q11","q12","q13a","q13b","q14","q15a,b","q15b","q16","q17","q18","q19","q20","q21","q22","q23","q24","q25"]
[null,"Surface Area","Proportion Recipe Questions ","AO3 Multiplication Problem","Probability and Relative Frequency","Questionnaires","Functional Maths Questions ","Ratio ","Area of Compound Shapes","Angles in Parallel Lines","Trial and Improvement ","Probability and Problem Solving","Solving Equations ","midpoint","Y=MX+ C Harder","Compound Interest & Depreciation","Drawing Quadratic Graphs","Solving Simultaneous Equations Graphically","Circle Theorems","Box plots","More Difficult Rearranging Formulae","Expand & Factorise Quadratics","Trigonometry","Stratified Sampling","Money problem Solving","Upper and Lower Bounds","Sine, Cosine Rules & Area of Triangles","Solving Quadratics Using the Formula"]
["Max Mark",3,4,4,3,5,4,4,4,4,4,3,5,2,2,4,4,2,5,4,3,4,3,2,3,4,5,6]
["Class Average (%)",{"$f":"AVERAGE(B9:B40)/B$4","v":0.5714285714285714},{"$f":"AVERAGE(C9:C40)/C$4","v":0.4732142857142857},0.5178571428571429,0.48809523809523808,0.54285714285714293,0.44642857142857145,0.4017857142857143,0.5,0.4375,0.44642857142857145,0.5,0.54285714285714293,0.4642857142857143,0.35714285714285715,0.4732142857142857,0.5535714285714286,0.42857142857142855,0.49285714285714288,0.5267857142857143,0.55952380952380953,0.5,0.5714285714285714,0.4642857142857143,0.47619047619047622,0.42857142857142855,0.45,0.44047619047619047]
["Standard Deviation",{"$f":"STDEV(B9:B39)/B$4","v":0.32530002431617772},{"$f":"STDEV(C9:C39)/C$4","v":0.33568121530237333},0.28810179711804212,0.2793605699491753,0.29743168705705936,0.29935998750067133,0.29138308209142916,0.3042903097250923,0.26020824993326658,0.30699516567208635,0.32075014954979209,0.32137271707539716,0.30210898905832195,0.35634832254989918,0.36221595330050943,0.24867373069671908,0.35261682367496922,0.29555794246559736,0.30686048912878927,0.32777553581871594,0.34020690871988585,0.31239342685979915,0.35819949512370663,0.35634832254989918,0.28752731639264756,0.2860976264351941,0.28765507792589889]
[null,"q1","q2","q3","q4","q5","q6","q7","q8","q9","q10","q11","q12","q13a","q13b","q14","q15a,b","q15b","q16","q17","q18","q19","q20","q21","q22","q23","q24","q25","Total Marks","Grade"]
["Name"]
["Sample student 1",{"$f":"ROUND(RAND()*B$4,0)","v":2},{"$f":"ROUND(RAND()*C$4,0)","v":3},3,1,1,4,3,1,1,3,2,4,1,1,3,3,1,4,3,3,0,3,0,1,2,0,0,{"$f":"IF(AB9=\"\",\"\",SUM(B9:AB9))","v":53},{"$f":"IF(AC9=\"\",\"\",VLOOKUP(AC9,$AF$13:$AG$34,2))","v":"B3"}]
["Sample student 2",{"$f":"ROUND(RAND()*B$4,0)","v":2},2,0,1,1,2,2,2,1,3,1,5,1,0,1,3,2,1,3,1,2,3,0,2,2,3,1,{"$f":"IF(AB10=\"\",\"\",SUM(B10:AB10))","v":47},{"$f":"IF(AC10=\"\",\"\",VLOOKUP(AC10,$AF$13:$AG$34,2))","v":"C1"},null,"Grade Boundaries"]
["Sample student 3",1,4,2,1,3,2,3,2,2,2,1,3,1,2,2,1,0,2,1,1,1,3,1,0,2,2,4,49,"B3"]
["Sample student 4",0,4,1,1,3,0,1,4,0,2,1,3,1,1,1,4,0,3,1,1,4,2,2,3,1,3,2,49,"B3",null,"Non- Calc"]
["Sample student 5",2,2,2,2,2,0,2,3,0,1,1,4,1,0,2,2,0,3,3,3,4,0,0,2,2,0,4,47,"C1",null,0,"F3"]
["Sample student 6",1,0,3,1,4,1,2,1,2,0,1,4,1,0,3,1,1,4,2,2,3,1,1,3,4,3,6,55,"B2",null,{"$f":"AF13+(AF16-AF13)/3","v":2.3333333333333335},"F2"]
["Sample student 7",2,0,2,2,4,1,0,0,3,1,2,3,1,1,0,2,1,2,3,2,1,2,2,1,2,4,1,45,"C1",null,{"$f":"AF13+2*(AF16-AF13)/3","v":4.666666666666667},"F1"]
["Sample student 8",2,0,4,1,2,2,0,3,3,1,1,4,0,2,4,3,0,4,3,0,2,3,0,2,3,3,4,56,"B2",null,7,"E3"]
["Sample student 9",3,1,1,1,4,3,1,2,3,4,0,2,2,1,3,3,0,5,0,1,3,1,2,1,1,4,2,54,"B3",null,{"$f":"AF16+(AF19-AF16)/3","v":9.3333333333333339},"E2"]
["Sample student 10",3,2,4,2,0,2,2,1,3,1,3,4,0,1,4,1,1,3,3,2,1,2,0,3,3,3,2,56,"B2",null,{"$f":"AF16+2*(AF19-AF16)/3","v":11.666666666666668},"E1"]
["Sample student 11",2,2,1,3,2,3,0,3,1,3,2,4,1,1,0,1,2,1,1,0,4,3,2,2,3,1,5,53,"B3",null,14,"D3"]
["Sample student 12",2,0,3,2,4,2,3,4,1,0,1,1,1,1,4,3,0,5,3,2,3,1,1,2,3,2,4,58,"B2",null,{"$f":"AF19+(AF22-AF19)/3","v":19},"D2"]
["Sample student 13",0,4,2,1,2,1,0,3,2,2,1,4,1,2,4,1,2,2,2,3,1,1,1,1,0,3,1,47,"C1",null,{"$f":"AF19+2*(AF22-AF19)/3","v":24},"D1"]
["Sample student 14",2,3,2,2,4,4,1,2,3,2,2,0,0,2,4,2,0,1,1,2,0,2,1,2,1,4,2,51,"B3",null,29,"C3"]
["Sample student 15",3,0,1,0,3,0,1,3,1,0,3,0,1,0,0,3,2,2,3,3,2,1,1,0,2,1,3,39,"C2",null,{"$f":"AF22+(AF25-AF22)/3","v":35.333333333333336},"C2"]
["Sample student 16",2,1,3,2,5,3,1,2,2,2,3,1,1,1,1,2,0,{"$f":"ROUND(RAND()*S$4,0)","v":0},1,1,3,1,0,1,1,3,1,44,"C1",null,{"$f":"AF22+2*(AF25-AF22)/3","v":41.666666666666664},"C1"]
["Sample student 17",0,2,2,1,1,1,2,0,3,2,2,2,0,1,0,{"$f":"ROUND(RAND()*Q$4,0)","v":1},1,1,2,1,2,2,0,0,3,1,6,39,"C2",null,48,"B3"]
["Sample student 18",{"$f":"ROUND(RAND()*B$4,0)","v":2},2,4,2,1,2,0,1,3,3,1,3,1,1,0,3,1,1,2,3,1,1,1,0,0,0,3,42,"C1",null,{"$f":"AF25+(AF28-AF25)/3","v":54.666666666666664},"B2"]
["Sample student 19",2,1,3,1,4,3,3,1,2,3,0,0,2,1,2,3,1,3,3,3,3,1,1,2,2,3,1,54,"B3",null,{"$f":"AF25+2*(AF28-AF25)/3","v":61.333333333333336},"B1"]
["Sample student 20",0,4,3,2,2,1,2,2,0,3,1,4,2,0,1,1,0,1,4,2,1,3,1,0,0,3,4,47,"C1",null,68,"A3"]
["Sample student 21",3,2,0,0,5,2,0,3,1,0,0,4,1,0,0,3,1,2,3,1,1,1,1,2,3,4,4,47,"C1",null,{"$f":"AF28+(AF31-AF28)/3","v":73.666666666666671},"A2"]
["Sample student 22",2,3,1,0,3,3,2,4,2,2,1,0,1,0,2,1,1,1,4,2,0,3,1,0,2,3,5,49,"B3",null,{"$f":"AF28+2*(AF31-AF28)/3","v":79.333333333333329},"A1"]
["Sample student 23",2,2,1,1,3,0,3,1,2,3,3,3,1,0,1,2,1,4,0,1,0,2,1,0,3,1,3,44,"C1",null,85," A*3"]
["Sample student 24",2,3,1,3,0,1,3,1,1,0,3,1,2,0,2,2,1,1,0,0,4,1,0,3,1,0,0,36,"C2",null,{"$f":"AF31+(AF34-AF31)/3","v":90},"A*2"]
["Sample student 25",3,2,3,3,5,2,3,3,0,1,0,4,1,0,1,3,1,4,4,1,3,0,2,1,1,1,1,53,"B3",null,{"$f":"AF31+2*(AF34-AF31)/3","v":95},"A*1"]
["Sample student 26",0,3,3,2,3,2,0,0,2,0,2,5,1,1,2,4,1,1,1,2,4,2,1,2,0,5,1,50,"B3",null,100,"A*1"]
["Sample student 27",2,0,1,1,1,0,2,1,2,3,2,1,0,0,4,3,2,5,1,3,1,1,2,1,1,2,2,44,"C1"]
["Sample student 28",1,1,2,2,4,3,3,3,3,3,2,3,0,0,2,1,1,3,2,1,2,2,1,3,0,1,2,51,"B3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,85,68,48,29,14,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]